Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Feb 27, 2024

Re: Divide the value from month granularity in one table to daily granularity in another table

Hi SergeiBaklan 

 

Many thanks for the lovely solution sir!:smile:

This solution has worked like a gem and as always you & your quick solution rocks!

you made my day!

 

We need your help in resolving the below issue:

we are trying to dynamically change between profile,direct and target units by referencing them in below measures that point to field parameters

Priority 1 units measures point to Parameter 4 field parameter table
Priority 2 units measures point to Parameter 5 table
Priority 3 units measures point to Parameter 6 table
 
When I drag them in below visual it shows blank for INSE-100:

 

But in data view there is a value for target but not showing in visual:

 

PFA file here https://1drv.ms/u/s!AhUFhM5jR1jqkDlvecc-0Sz09Dr8?e=edTAsd

Please help in resolving this Sir!

 

Thanks in advance!

 

5 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 27, 2024

    Excellove15 

    If in code for the Priority 3 to change

    it is shown

    Not sure about other measures

    • Excellove15's avatar
      Excellove15
      Iron Contributor
      Feb 28, 2024

      Hi SergeiBaklan 

       

      Many thanks for this amazing quick solution Sir!:smile:

      I tried the same in my file, but still i am getting blanks.

      If you don't mind, can you please send me the file so that i can have a look into changes and update my file for other measures as well

      Also, i have marked your solution as the best response!

       

      Thanks in advance!

Resources