Forum Discussion

lafakios's avatar
lafakios
Icon for Helper I rankHelper I
1 year ago

Thank you for building a PBIx report and sharing it, this actually does provide the needed functionality!

 

One of the key calculated columns is the below:

Column = CALCULATE(DISTINCTCOUNT('Table'[Item_ID]),FILTER('Table','Table'[param_id]=EARLIER('Table'[param_id])&&'Table'[item]=EARLIER('Table'[item])&&'Table'[Item_ID]>=EARLIER('Table'[Item_ID])))
 
I did a quick check if the above logic can scale to more than 4 items e.g. to support also items like itemA 1.5, 1.6, 1.7 etc. and the check result was successful.
 
One minor drawback of the current solution is that the column header in the visual refers to a measure name and not to the actual item represented by the measure e.g. itemA 1.4, 1.3, 1.2
lafakios's avatar
lafakios
Icon for Helper I rankHelper I
1 year ago

Hi,

 

In the shared report, I would like to add a Card visual which will display the number of params  per item that have a High or Low value. 

 

After experimenting a bit, this does not seem to be simple to implement.

 

Attempt 1

I have created the below measure and added in a card visual.

I have then added the measure 'Measure 3 HoL' as a card visual filter and I am not able to set its value. 

 

_CountOfParams = CALCULATE(DISTINCTCOUNTNOBLANK('Table'[param_id]))

 

Attempt 2

I have created the below measures and added then in two card visuals.

Both card visuals show exactly the same number, 5. This is the total number of params.

They should instead return respectively 3 and 2.

 

_CountOfHighParams = CALCULATE(DISTINCTCOUNTNOBLANK('Table'[param_id]), filter('Table','Table'[Measure 3 HoL] = "H"))
 
_CountOfLowParams = CALCULATE(DISTINCTCOUNTNOBLANK('Table'[param_id]), filter('Table','Table'[Measure 3 HoL] = "L"))
 
I have also updated the shared pbix file with the abovementioned measures and visuals and I am unfortunately not able to attach it in the post. I am just sharing a screenshot of the report page.
 
Any suggestions and ideas are more than welcome.
 
Regards,
Akis